/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package thienphuc.patient.dao;

import java.util.Date;
import java.util.List;
import thienphuc.patient.dto.NhapThuoc;
import thienphuc.patient.dto.NhapThuocId;
import thienphuc.patient.dto.Thuoc;

/**
 *
 * @author QuocDat
 */
public interface NhapThuocDAO extends Dao<NhapThuoc, NhapThuocId> {
    public final static String NHAP_THUOC_ID = "id";
    public final static String NHAP_THUOC_THUOC = "thuoc";
    public final static String NHAP_THUOC_NGAY_NHAP = "ngayNhap";
    public final static String NHAP_THUOC_TEN_CONG_TY = "tenCongTy";
    public final static String NHAP_THUOC_GIA_NHAP = "giaNhap";
    public final static String NHAP_THUOC_SO_LUONG = "soLuong";
    public final static String NHAP_THUOC_NGAY_SAN_XUAT = "ngaySanXuat";
    public final static String NHAP_THUOC_HAN_SU_DUNG = "hanSuDung";
    public final static String NHAP_THUOC_KHOS = "khos";
    
    /**
     * Find NhapThuoc by Thuoc
     * @param thuoc
     * @return
     * @throws Exception 
     */
    List<NhapThuoc> findByThuoc(Thuoc thuoc) throws Exception;
    
    /**
     * Find NhapThuoc by NgayNhap
     * @param ngayNhapStart
     * @param ngayNhapEnd
     * @return
     * @throws Exception 
     */
    List<NhapThuoc> findByNgayNhap(Date ngayNhapStart, Date ngayNhapEnd) throws Exception;
    
    /**
     * Find NhapThuoc by TenCongTy
     * @param tenCongTy
     * @return
     * @throws Exception 
     */
    List<NhapThuoc> findByTenCongTy(String tenCongTy) throws Exception;
    
}
